Connector (Hidden)
Entity
Frame (Hidden)
Relationship
GL-0020
PERIOD_NAME
From GL ACCOUNT BALANCE To REPORTING PERIOD
GL-0020 Relationship PERIOD_NAME From GL ACCOUNT BALANCE To REPORTING PERIOD Joe Bloggs
PERIOD_NAME
GL-0011
JOURNAL_NO
From GL BATCH To GL JOURNAL
GL-0011 Relationship JOURNAL_NO From GL BATCH To GL JOURNAL Adam Smith
JOURNAL_NO
GL-0012
BATCH_NO
From GL ENTRY To GL BATCH
GL-0012 Relationship BATCH_NO From GL ENTRY To GL BATCH Nancy Nerk
BATCH_
NO
GL-0013
ACCOUNT_NO
From GL ENTRY TO GL ACCOUNT
GL-0013 Relationship ACCOUNT_NO From GL ENTRY TO GL ACCOUNT Benjamin Graham
ACCOUNT_NO
GL-0014
LOCATION_ID
From GL ENTRY To LOCATION
GL-0014 Relationship LOCATION_ID From GL ENTRY To LOCATION Joe Bloggs
LOCATION_ID
GL-0015
DEPARTMENT_ID
From GL ENTRY To DEPARTMENT
GL-0015 Relationship DEPARTMENT_ID From GL ENTRY To DEPARTMENT Joe Bloggs
DEPARTMENT_ID
GL-0016
DIMKEY
From GL ENTRY To DIMENSION
GL-0016 Relationship DIMKEY From GL ENTRY To DIMENSION Nancy Nerk
DIMKEY
GL-0017
DIMKEY
From GL ACCOUNT BALANCE To DIMENSION
GL-0017 Relationship DIMKEY From GL ACCOUNT BALANCE To DIMENSION Joe Bloggs
DIMKEY
GL-0018
DEPARTMENT_ID
From GL ACCOUNT BALANCE To DEPARTMENT
GL-0018 Relationship DEPARTMENT_ID From GL ACCOUNT BALANCE To DEPARTMENT Benjamin Graham
DEPARTMENT_
ID
GL-0021
ACCOUNT_NO
From GL ACCOUNT BALANCE TO GL ACCOUNT
GL-0021 Relationship ACCOUNT_NO From GL ACCOUNT BALANCE TO GL ACCOUNT Benjamin Graham
ACCOUNT_NO
GL-0001
GL JOURNAL
RECORD_NO [PK] JOURNAL_NO [UQ] BOOK_ID TITLE
GL-0001 Entity GL JOURNAL RECORD_NO [PK] JOURNAL_NO [UQ] BOOK_ID TITLE Joe Bloggs
RECORD_NO [PK]
JOURNAL_NO [UQ]
BOOK_ID
TITLE
GL JOURNAL
GL-0002
GL BATCH
RECORD_NO [PK] BATCH_NO [UQ] JOURNAL_NO [FK]
GL-0002 Entity GL BATCH RECORD_NO [PK] BATCH_NO [UQ] JOURNAL_NO [FK] Nancy Nerk
RECORD_NO [PK]
BATCH_NO [UQ]
JOURNAL_NO [FK]
GL BATCH
GL-0003
GL ENTRY
RECORD_NO [PK] BATCH_NO [FK] ACCOUNT_NO [FK] LOCATION_ID [FK] DEPARTMENT_ID [FK] DIMKEY [FK]
GL-0003 Entity GL ENTRY RECORD_NO [PK] BATCH_NO [FK] ACCOUNT_NO [FK] LOCATION_ID [FK] DEPARTMENT_ID [FK] DIMKEY [FK] Adam Smith
RECORD_NO [PK]
BATCH_NO [FK]
ACCOUNT_NO [FK]
LOCATION_ID [FK]
DEPARTMENT_ID
[FK]
DIMKEY [FK]
GL ENTRY
GL-0004
LOCATION
RECORD_NO [PK] LOCATION_ID [UQ] NAME
GL-0004 Entity LOCATION RECORD_NO [PK] LOCATION_ID [UQ] NAME Benjamin Graham
RECORD_NO [PK]
LOCATION_ID [UQ]
NAME
LOCATION
GL-0005
DEPARTMENT
RECORD_NO [PK] DEPARTMENT_ID [UQ] TITLE
GL-0005 Entity DEPARTMENT RECORD_NO [PK] DEPARTMENT_ID [UQ] TITLE Joe Bloggs
RECORD_NO [PK]
DEPARTMENT_ID
[UQ]
TITLE
DEPARTMENT
GL-0006
DIMENSION
RECORD_NO [PK]
GL-0006 Entity DIMENSION RECORD_NO [PK] Joe Bloggs
RECORD_NO [PK]
DIMENSION
GL-0007
GL ACCOUNT BALANCE
ACCOUNT_NO [FK] OPEN_BAL END_BAL FOR_BAL CURRENCY LOCATION_ID [FK] DEPARTMENT_ID [FK] PERIOD_NAME [FK] DIMKEY [FK]
GL-0007 Entity GL ACCOUNT BALANCE ACCOUNT_NO [FK] OPEN_BAL END_BAL FOR_BAL CURRENCY LOCATION_ID [FK] DEPARTMENT_ID [FK] PERIOD_NAME [FK] DIMKEY [FK]
ACCOUNT_NO [FK]
OPEN_BAL
END_BAL
FOR_BAL
CURRENCY
LOCATION_ID [FK]
DEPARTMENT_ID [FK]
PERIOD_NAME [FK]
DIMKEY [FK]
GL ACCOUNT BALANCE
GL-0008
GL ACCOUNT
RECORD_NO [PK] ACCOUNT_NO [UQ] TITLE
GL-0008 Entity GL ACCOUNT RECORD_NO [PK] ACCOUNT_NO [UQ] TITLE Adam Smith
RECORD_NO [PK]
ACCOUNT_NO [UQ]
TITLE
GL ACCOUNT
GL-0010
REPORTING PERIOD
RECORD_NO [PK] PERIOD_NAME [UQ] START_DATE END_DATE BUDGETING
GL-0010 Entity REPORTING PERIOD RECORD_NO [PK] PERIOD_NAME [UQ] START_DATE END_DATE BUDGETING Benjamin Graham
RECORD_NO [PK]
PERIOD_NAME [UQ]
START_DATE
END_DATE
BUDGETING
REPORTING PERIOD
GL-0019
LOCATION_ID
From GL ACCOUNT BALANCE To LOCATION
GL-0019 Relationship LOCATION_ID From GL ACCOUNT BALANCE To LOCATION Joe Bloggs
LOCATION_ID
×